2013-05-14 - 6856.200 - Rel Notes - Fix FI110 - Income Statement #BIReleases2013

Release Notes:

6856.200 - FI110 - Income Statement Redesign


Admin Info


Purpose
FI110 report to return correct data when entering period 1-4 as parameter
Release No
001
Submitted
05/14/2013
Submitted by
Naga Brahmam R
Source/Destination Systems
IT > BMS > Development in BI 4.0 Dev
Release Sent To
Jack Mehltretter
Object(s) Created By
Naga Brahmam R
Object(s) Tested By
Naga Brahmam R

Report Name


FI110 - Income Statement

BEx Query


ZMP_GLPC_Q001

NEC Crystal Reports Standards Check


1. FI110 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. FI110 NEC CR checklist has been sent to NEC and also attached here for reference:

FI110 NEC CR Standard Check List.xlsx

Summary Level Check


Test Conducted

Parameters : Period Range - [1-3], Fiscal year - 2013, Watermark - Preliminary.
Group - NEC, Inc. USA > Gross Profit
SNo
Test Case
Value in BO 3.1
Value in BI 4.0
Pass/Fail
1
Actual Period
22,540,906
22,540,906
Pass
2
Budget Period
26,891,446
26,891,446
Pass
3
Variance Period
-4,350,540
-4,350,540
Pass
4
Variance Period %
-16%
-16%
Pass
5
Actual YTD
53,651,704
53,651,704
Pass
6
Budget YTD
62,783,672
62,783,672
Pass
7
Vatiance YTD
-9,131,968
-9,131,968
Pass
8
Variance YTD %
-15%
-15%
Pass

Parameters : Period Range - [1-4], Fiscal year - 2013, Watermark - Preliminary.
Group - 5th & Ocean Clothing, LLC > Cost of goods sold
SNo
Test Case
Value in BEx
Value in BI 4.0
Pass/Fail
1
Actual Period
3,938,246.78
3,938,247
Pass
2
Budget Period
5,425,511.00
5,425,511
Pass
3
Variance Period
-1,487,264.22
-1,487,264
Pass
4
Variance Period %
-27%
-27%
Pass
5
Actual YTD
21,971,678.90
21,971,679
Pass
6
Budget YTD
26,964,759.00
26,964,759
Pass
7
Vatiance YTD
4,993,081
4,993,080
Pass
8
Variance YTD %
-15%
-15%
Pass

Reference Document(Specification)


2013-05-10 - 6856.200 - Spec - Fix FI110 - Income Statement